Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 177512 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 23.2 MiB |
| Average record size in memory | 137.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 8 |
| Boolean | 1 |
rate is highly correlated with rate_var | High correlation |
rate_var is highly correlated with rate | High correlation |
provider_name is highly correlated with click_type | High correlation |
click_type is highly correlated with provider_name | High correlation |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
Time_of_day has 2817 (1.6%) zeros | Zeros |
rate_var has 20961 (11.8%) zeros | Zeros |
Big4Weight has 83856 (47.2%) zeros | Zeros |
Reproduction
| Analysis started | 2021-02-01 02:39:02.428265 |
|---|---|
| Analysis finished | 2021-02-01 02:40:14.204074 |
| Duration | 1 minute and 11.78 seconds |
| Software version | pandas-profiling v2.10.0 |
| Download configuration | config.yaml |
| Distinct | 177512 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 88756.5 |
|---|---|
| Minimum | 1 |
| Maximum | 177512 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 8876.55 |
| Q1 | 44378.75 |
| median | 88756.5 |
| Q3 | 133134.25 |
| 95-th percentile | 168636.45 |
| Maximum | 177512 |
| Range | 177511 |
| Interquartile range (IQR) | 88755.5 |
Descriptive statistics
| Standard deviation | 51243.44483 |
|---|---|
| Coefficient of variation (CV) | 0.577348643 |
| Kurtosis | -1.2 |
| Mean | 88756.5 |
| Median Absolute Deviation (MAD) | 44378 |
| Skewness | 0 |
| Sum | 1.575534383 × 1010 |
| Variance | 2625890638 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) |
| 2047 | 1 | < 0.1% |
| 64821 | 1 | < 0.1% |
| 48445 | 1 | < 0.1% |
| 46396 | 1 | < 0.1% |
| 36155 | 1 | < 0.1% |
| 34106 | 1 | < 0.1% |
| 40249 | 1 | < 0.1% |
| 38200 | 1 | < 0.1% |
| 60727 | 1 | < 0.1% |
| 58678 | 1 | < 0.1% |
| Other values (177502) | 177502 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 |
| Value | Count | Frequency (%) |
| 177512 | 1 | |
| 177511 | 1 | |
| 177510 | 1 | |
| 177509 | 1 | |
| 177508 | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| GTS | |
|---|---|
| Lead |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.134914823 |
| Min length | 3 |
Characters and Unicode
| Total characters | 556485 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | GTS |
|---|---|
| 2nd row | GTS |
| 3rd row | GTS |
| 4th row | GTS |
| 5th row | GTS |
| Value | Count | Frequency (%) |
| GTS | 153563 | |
| Lead | 23949 | 13.5% |
| Value | Count | Frequency (%) |
| gts | 153563 | |
| lead | 23949 | 13.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 153563 | |
| T | 153563 | |
| S | 153563 | |
| L | 23949 | 4.3% |
| e | 23949 | 4.3% |
| a | 23949 | 4.3% |
| d | 23949 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 484638 | |
| Lowercase Letter | 71847 | 12.9% |
Most frequent character per category
| Value | Count | Frequency (%) |
| G | 153563 | |
| T | 153563 | |
| S | 153563 | |
| L | 23949 | 4.9% |
| Value | Count | Frequency (%) |
| e | 23949 | |
| a | 23949 | |
| d | 23949 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 556485 |
Most frequent character per script
| Value | Count | Frequency (%) |
| G | 153563 | |
| T | 153563 | |
| S | 153563 | |
| L | 23949 | 4.3% |
| e | 23949 | 4.3% |
| a | 23949 | 4.3% |
| d | 23949 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 556485 |
Most frequent character per block
| Value | Count | Frequency (%) |
| G | 153563 | |
| T | 153563 | |
| S | 153563 | |
| L | 23949 | 4.3% |
| e | 23949 | 4.3% |
| a | 23949 | 4.3% |
| d | 23949 | 4.3% |
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.18273694 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros | 2817 |
| Zeros (%) | 1.6% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 10 |
| median | 14 |
| Q3 | 19 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 5.365422795 |
|---|---|
| Coefficient of variation (CV) | 0.3783065862 |
| Kurtosis | -0.4120961924 |
| Mean | 14.18273694 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.360679859 |
| Sum | 2517606 |
| Variance | 28.78776177 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 11606 | 6.5% |
| 13 | 11429 | 6.4% |
| 12 | 11354 | 6.4% |
| 14 | 11221 | 6.3% |
| 21 | 11131 | 6.3% |
| 16 | 10975 | 6.2% |
| 15 | 10848 | 6.1% |
| 10 | 10687 | 6.0% |
| 11 | 10337 | 5.8% |
| 19 | 10280 | 5.8% |
| Other values (14) | 67644 |
| Value | Count | Frequency (%) |
| 0 | 2817 | |
| 1 | 1594 | |
| 2 | 967 | 0.5% |
| 3 | 686 | 0.4% |
| 4 | 1013 | 0.6% |
| Value | Count | Frequency (%) |
| 23 | 5349 | |
| 22 | 8422 | |
| 21 | 11131 | |
| 20 | 11606 | |
| 19 | 10280 |
weekday
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Wednesday | |
|---|---|
| Tuesday | |
| Monday | |
| Thursday | |
| Friday | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.221247014 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1281858 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Friday |
|---|---|
| 2nd row | Friday |
| 3rd row | Friday |
| 4th row | Friday |
| 5th row | Friday |
| Value | Count | Frequency (%) |
| Wednesday | 31441 | |
| Tuesday | 30559 | |
| Monday | 27672 | |
| Thursday | 27468 | |
| Friday | 24726 | |
| Saturday | 18484 | |
| Sunday | 17162 |
| Value | Count | Frequency (%) |
| wednesday | 31441 | |
| tuesday | 30559 | |
| monday | 27672 | |
| thursday | 27468 | |
| friday | 24726 | |
| saturday | 18484 | |
| sunday | 17162 |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 208953 | |
| a | 195996 | |
| y | 177512 | |
| u | 93673 | |
| e | 93441 | |
| s | 89468 | |
| n | 76275 | 6.0% |
| r | 70678 | 5.5% |
| T | 58027 | 4.5% |
| S | 35646 | 2.8% |
| Other values (7) | 182189 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1104346 | |
| Uppercase Letter | 177512 | 13.8% |
Most frequent character per category
| Value | Count | Frequency (%) |
| d | 208953 | |
| a | 195996 | |
| y | 177512 | |
| u | 93673 | |
| e | 93441 | |
| s | 89468 | |
| n | 76275 | 6.9% |
| r | 70678 | 6.4% |
| o | 27672 | 2.5% |
| h | 27468 | 2.5% |
| Other values (2) | 43210 | 3.9% |
| Value | Count | Frequency (%) |
| T | 58027 | |
| S | 35646 | |
| W | 31441 | |
| M | 27672 | |
| F | 24726 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1281858 |
Most frequent character per script
| Value | Count | Frequency (%) |
| d | 208953 | |
| a | 195996 | |
| y | 177512 | |
| u | 93673 | |
| e | 93441 | |
| s | 89468 | |
| n | 76275 | 6.0% |
| r | 70678 | 5.5% |
| T | 58027 | 4.5% |
| S | 35646 | 2.8% |
| Other values (7) | 182189 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1281858 |
Most frequent character per block
| Value | Count | Frequency (%) |
| d | 208953 | |
| a | 195996 | |
| y | 177512 | |
| u | 93673 | |
| e | 93441 | |
| s | 89468 | |
| n | 76275 | 6.0% |
| r | 70678 | 5.5% |
| T | 58027 | 4.5% |
| S | 35646 | 2.8% |
| Other values (7) | 182189 |
position
Real number (ℝ≥0)
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.148046329 |
|---|---|
| Minimum | 1 |
| Maximum | 23 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 7 |
| Q3 | 13 |
| 95-th percentile | 18 |
| Maximum | 23 |
| Range | 22 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 5.537035408 |
|---|---|
| Coefficient of variation (CV) | 0.6795537462 |
| Kurtosis | -0.8320594955 |
| Mean | 8.148046329 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.5020465854 |
| Sum | 1446376 |
| Variance | 30.6587611 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 17073 | 9.6% |
| 2 | 15733 | 8.9% |
| 3 | 14139 | 8.0% |
| 4 | 12829 | 7.2% |
| 5 | 11951 | 6.7% |
| 6 | 11332 | 6.4% |
| 7 | 10756 | 6.1% |
| 8 | 10179 | 5.7% |
| 9 | 9066 | 5.1% |
| 12 | 8788 | 5.0% |
| Other values (13) | 55666 |
| Value | Count | Frequency (%) |
| 1 | 17073 | |
| 2 | 15733 | |
| 3 | 14139 | |
| 4 | 12829 | |
| 5 | 11951 |
| Value | Count | Frequency (%) |
| 23 | 254 | 0.1% |
| 22 | 415 | 0.2% |
| 21 | 2139 | |
| 20 | 1753 | |
| 19 | 3251 |
device
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| desktop | |
|---|---|
| mobile | |
| tablet |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 6.493115958 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1152606 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | mobile |
|---|---|
| 2nd row | mobile |
| 3rd row | mobile |
| 4th row | mobile |
| 5th row | mobile |
| Value | Count | Frequency (%) |
| desktop | 87534 | |
| mobile | 76965 | |
| tablet | 13013 | 7.3% |
| Value | Count | Frequency (%) |
| desktop | 87534 | |
| mobile | 76965 | |
| tablet | 13013 | 7.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 177512 | |
| o | 164499 | |
| t | 113560 | |
| b | 89978 | |
| l | 89978 | |
| d | 87534 | |
| s | 87534 | |
| k | 87534 | |
| p | 87534 | |
| m | 76965 | |
| Other values (2) | 89978 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1152606 |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 177512 | |
| o | 164499 | |
| t | 113560 | |
| b | 89978 | |
| l | 89978 | |
| d | 87534 | |
| s | 87534 | |
| k | 87534 | |
| p | 87534 | |
| m | 76965 | |
| Other values (2) | 89978 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1152606 |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 177512 | |
| o | 164499 | |
| t | 113560 | |
| b | 89978 | |
| l | 89978 | |
| d | 87534 | |
| s | 87534 | |
| k | 87534 | |
| p | 87534 | |
| m | 76965 | |
| Other values (2) | 89978 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1152606 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 177512 | |
| o | 164499 | |
| t | 113560 | |
| b | 89978 | |
| l | 89978 | |
| d | 87534 | |
| s | 87534 | |
| k | 87534 | |
| p | 87534 | |
| m | 76965 | |
| Other values (2) | 89978 |
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| loans.com.au | |
|---|---|
| UBank | |
| HSBC | |
| ME | |
| Virgin Money | |
| Other values (24) |
Length
| Max length | 19 |
|---|---|
| Median length | 9 |
| Mean length | 9.367428681 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1662831 |
|---|---|
| Distinct characters | 44 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Newcastle Permanent |
|---|---|
| 2nd row | ME |
| 3rd row | NAB |
| 4th row | AMP |
| 5th row | loans.com.au |
| Value | Count | Frequency (%) |
| loans.com.au | 27660 | |
| UBank | 14305 | 8.1% |
| HSBC | 13945 | 7.9% |
| ME | 12975 | 7.3% |
| Virgin Money | 11653 | 6.6% |
| Newcastle Permanent | 9628 | 5.4% |
| Athena | 9242 | 5.2% |
| Hunter United | 8721 | 4.9% |
| Bank Australia | 6909 | 3.9% |
| QBANK | 6467 | 3.6% |
| Other values (19) | 56007 |
| Value | Count | Frequency (%) |
| loans.com.au | 27660 | 11.0% |
| bank | 26553 | 10.6% |
| ubank | 14305 | 5.7% |
| hsbc | 13945 | 5.6% |
| me | 12975 | 5.2% |
| virgin | 11653 | 4.6% |
| money | 11653 | 4.6% |
| permanent | 9628 | 3.8% |
| newcastle | 9628 | 3.8% |
| athena | 9242 | 3.7% |
| Other values (27) | 103361 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 179651 | 10.8% |
| n | 158203 | 9.5% |
| e | 127793 | 7.7% |
| o | 92897 | 5.6% |
| s | 83861 | 5.0% |
| t | 82206 | 4.9% |
| 73091 | 4.4% | |
| B | 67610 | 4.1% |
| u | 67091 | 4.0% |
| i | 65974 | 4.0% |
| Other values (34) | 664454 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1184985 | |
| Uppercase Letter | 346003 | 20.8% |
| Space Separator | 73091 | 4.4% |
| Other Punctuation | 58752 | 3.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| a | 179651 | |
| n | 158203 | |
| e | 127793 | |
| o | 92897 | |
| s | 83861 | 7.1% |
| t | 82206 | 6.9% |
| u | 67091 | 5.7% |
| i | 65974 | 5.6% |
| r | 55390 | 4.7% |
| l | 53225 | 4.5% |
| Other values (11) | 218694 |
| Value | Count | Frequency (%) |
| B | 67610 | |
| A | 41074 | |
| H | 35563 | |
| M | 32212 | |
| C | 23031 | 6.7% |
| U | 23026 | 6.7% |
| N | 22433 | 6.5% |
| S | 19277 | 5.6% |
| Q | 16767 | 4.8% |
| E | 13650 | 3.9% |
| Other values (10) | 51360 |
| Value | Count | Frequency (%) |
| . | 55320 | |
| : | 3432 | 5.8% |
| Value | Count | Frequency (%) |
| 73091 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1530988 | |
| Common | 131843 | 7.9% |
Most frequent character per script
| Value | Count | Frequency (%) |
| a | 179651 | 11.7% |
| n | 158203 | 10.3% |
| e | 127793 | 8.3% |
| o | 92897 | 6.1% |
| s | 83861 | 5.5% |
| t | 82206 | 5.4% |
| B | 67610 | 4.4% |
| u | 67091 | 4.4% |
| i | 65974 | 4.3% |
| r | 55390 | 3.6% |
| Other values (31) | 550312 |
| Value | Count | Frequency (%) |
| 73091 | ||
| . | 55320 | |
| : | 3432 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1662831 |
Most frequent character per block
| Value | Count | Frequency (%) |
| a | 179651 | 10.8% |
| n | 158203 | 9.5% |
| e | 127793 | 7.7% |
| o | 92897 | 5.6% |
| s | 83861 | 5.0% |
| t | 82206 | 4.9% |
| 73091 | 4.4% | |
| B | 67610 | 4.1% |
| u | 67091 | 4.0% |
| i | 65974 | 4.0% |
| Other values (34) | 664454 |
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.709884909 |
|---|---|
| Minimum | 3.39 |
| Maximum | 4.53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 3.39 |
|---|---|
| 5-th percentile | 3.48 |
| Q1 | 3.59 |
| median | 3.68 |
| Q3 | 3.86 |
| 95-th percentile | 3.99 |
| Maximum | 4.53 |
| Range | 1.14 |
| Interquartile range (IQR) | 0.27 |
Descriptive statistics
| Standard deviation | 0.1768662397 |
|---|---|
| Coefficient of variation (CV) | 0.04767431984 |
| Kurtosis | -0.5207700426 |
| Mean | 3.709884909 |
| Median Absolute Deviation (MAD) | 0.09 |
| Skewness | 0.6118866995 |
| Sum | 658549.09 |
| Variance | 0.03128166676 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.59 | 36330 | |
| 3.99 | 20590 | |
| 3.69 | 18627 | |
| 3.48 | 13097 | 7.4% |
| 3.89 | 12723 | 7.2% |
| 3.64 | 11354 | 6.4% |
| 3.49 | 9065 | 5.1% |
| 3.76 | 6886 | 3.9% |
| 3.97 | 6768 | 3.8% |
| 3.58 | 5714 | 3.2% |
| Other values (18) | 36358 |
| Value | Count | Frequency (%) |
| 3.39 | 314 | 0.2% |
| 3.44 | 1246 | 0.7% |
| 3.47 | 2903 | 1.6% |
| 3.48 | 13097 | |
| 3.49 | 9065 |
| Value | Count | Frequency (%) |
| 4.53 | 1 | < 0.1% |
| 4.19 | 3180 | 1.8% |
| 3.99 | 20590 | |
| 3.97 | 6768 | 3.8% |
| 3.89 | 12723 |
experts_choice
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 173.5 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 138155 | |
| True | 39357 | 22.2% |
Region
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| New South Wales | |
|---|---|
| Victoria | |
| Queensland | |
| Western Australia | |
| South Australia | |
| Other values (3) | 5874 |
Length
| Max length | 28 |
|---|---|
| Median length | 15 |
| Mean length | 12.62542814 |
| Min length | 8 |
Characters and Unicode
| Total characters | 2241165 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Victoria |
|---|---|
| 2nd row | Victoria |
| 3rd row | Victoria |
| 4th row | Victoria |
| 5th row | South Australia |
| Value | Count | Frequency (%) |
| New South Wales | 65829 | |
| Victoria | 49816 | |
| Queensland | 29365 | |
| Western Australia | 15505 | 8.7% |
| South Australia | 11123 | 6.3% |
| Australian Capital Territory | 4047 | 2.3% |
| Tasmania | 1508 | 0.8% |
| Northern Territory | 319 | 0.2% |
| Value | Count | Frequency (%) |
| south | 76952 | |
| wales | 65829 | |
| new | 65829 | |
| victoria | 49816 | |
| queensland | 29365 | 8.5% |
| australia | 26628 | 7.7% |
| western | 15505 | 4.5% |
| territory | 4366 | 1.3% |
| capital | 4047 | 1.2% |
| australian | 4047 | 1.2% |
| Other values (2) | 1827 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 226083 | 10.1% |
| a | 218978 | 9.8% |
| t | 181680 | 8.1% |
| 166699 | 7.4% | |
| s | 142882 | 6.4% |
| i | 140228 | 6.3% |
| u | 136992 | 6.1% |
| o | 131453 | 5.9% |
| l | 129916 | 5.8% |
| r | 109732 | 4.9% |
| Other values (16) | 656522 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1730255 | |
| Uppercase Letter | 344211 | 15.4% |
| Space Separator | 166699 | 7.4% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 226083 | |
| a | 218978 | |
| t | 181680 | |
| s | 142882 | |
| i | 140228 | |
| u | 136992 | |
| o | 131453 | |
| l | 129916 | |
| r | 109732 | |
| n | 80109 | 4.6% |
| Other values (7) | 232202 |
| Value | Count | Frequency (%) |
| W | 81334 | |
| S | 76952 | |
| N | 66148 | |
| V | 49816 | |
| A | 30675 | 8.9% |
| Q | 29365 | 8.5% |
| T | 5874 | 1.7% |
| C | 4047 | 1.2% |
| Value | Count | Frequency (%) |
| 166699 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2074466 | |
| Common | 166699 | 7.4% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 226083 | 10.9% |
| a | 218978 | 10.6% |
| t | 181680 | 8.8% |
| s | 142882 | 6.9% |
| i | 140228 | 6.8% |
| u | 136992 | 6.6% |
| o | 131453 | 6.3% |
| l | 129916 | 6.3% |
| r | 109732 | 5.3% |
| W | 81334 | 3.9% |
| Other values (15) | 575188 |
| Value | Count | Frequency (%) |
| 166699 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2241165 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 226083 | 10.1% |
| a | 218978 | 9.8% |
| t | 181680 | 8.1% |
| 166699 | 7.4% | |
| s | 142882 | 6.4% |
| i | 140228 | 6.3% |
| u | 136992 | 6.1% |
| o | 131453 | 5.9% |
| l | 129916 | 5.8% |
| r | 109732 | 4.9% |
| Other values (16) | 656522 |
rate_rank
Real number (ℝ≥0)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.301821849 |
|---|---|
| Minimum | 1 |
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 11 |
| 95-th percentile | 16 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 4.839384593 |
|---|---|
| Coefficient of variation (CV) | 0.6627639914 |
| Kurtosis | -0.7357837919 |
| Mean | 7.301821849 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.5123256183 |
| Sum | 1296161 |
| Variance | 23.41964324 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 18360 | 10.3% |
| 2 | 16940 | 9.5% |
| 3 | 15291 | 8.6% |
| 4 | 13795 | 7.8% |
| 5 | 12641 | 7.1% |
| 6 | 11738 | 6.6% |
| 7 | 11066 | 6.2% |
| 8 | 10460 | 5.9% |
| 9 | 9906 | 5.6% |
| 10 | 9143 | 5.2% |
| Other values (11) | 48172 |
| Value | Count | Frequency (%) |
| 1 | 18360 | |
| 2 | 16940 | |
| 3 | 15291 | |
| 4 | 13795 | |
| 5 | 12641 |
| Value | Count | Frequency (%) |
| 21 | 175 | 0.1% |
| 20 | 468 | 0.3% |
| 19 | 1221 | 0.7% |
| 18 | 2417 | |
| 17 | 3055 |
min_interest
Real number (ℝ≥0)
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.497545631 |
|---|---|
| Minimum | 3.39 |
| Maximum | 3.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 3.39 |
|---|---|
| 5-th percentile | 3.44 |
| Q1 | 3.47 |
| median | 3.48 |
| Q3 | 3.49 |
| 95-th percentile | 3.59 |
| Maximum | 3.99 |
| Range | 0.6 |
| Interquartile range (IQR) | 0.02 |
Descriptive statistics
| Standard deviation | 0.05288952664 |
|---|---|
| Coefficient of variation (CV) | 0.01512189753 |
| Kurtosis | 2.728578476 |
| Mean | 3.497545631 |
| Median Absolute Deviation (MAD) | 0.01 |
| Skewness | 1.364241179 |
| Sum | 620856.32 |
| Variance | 0.002797302029 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.48 | 77645 | |
| 3.47 | 35501 | |
| 3.59 | 25565 | 14.4% |
| 3.44 | 17813 | 10.0% |
| 3.58 | 11397 | 6.4% |
| 3.49 | 5506 | 3.1% |
| 3.39 | 2097 | 1.2% |
| 3.64 | 1092 | 0.6% |
| 3.68 | 188 | 0.1% |
| 3.54 | 185 | 0.1% |
| Other values (12) | 523 | 0.3% |
| Value | Count | Frequency (%) |
| 3.39 | 2097 | 1.2% |
| 3.44 | 17813 | 10.0% |
| 3.47 | 35501 | |
| 3.48 | 77645 | |
| 3.49 | 5506 | 3.1% |
| Value | Count | Frequency (%) |
| 3.99 | 42 | |
| 3.89 | 2 | < 0.1% |
| 3.84 | 41 | |
| 3.8 | 7 | < 0.1% |
| 3.79 | 73 |
TotalImpressions
Real number (ℝ≥0)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.6036437 |
|---|---|
| Minimum | 1 |
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 11 |
| median | 15 |
| Q3 | 18 |
| 95-th percentile | 20 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 4.923808488 |
|---|---|
| Coefficient of variation (CV) | 0.3619477691 |
| Kurtosis | -0.2243364948 |
| Mean | 13.6036437 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.8171735153 |
| Sum | 2414810 |
| Variance | 24.24389003 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 15 | 23445 | |
| 18 | 21528 | |
| 14 | 17136 | 9.7% |
| 16 | 16224 | 9.1% |
| 19 | 14307 | 8.1% |
| 17 | 10846 | 6.1% |
| 13 | 8892 | 5.0% |
| 12 | 6924 | 3.9% |
| 9 | 6867 | 3.9% |
| 20 | 5860 | 3.3% |
| Other values (11) | 45483 |
| Value | Count | Frequency (%) |
| 1 | 1420 | 0.8% |
| 2 | 3298 | |
| 3 | 4488 | |
| 4 | 4616 | |
| 5 | 4515 |
| Value | Count | Frequency (%) |
| 21 | 3675 | 2.1% |
| 20 | 5860 | 3.3% |
| 19 | 14307 | |
| 18 | 21528 | |
| 17 | 10846 |
| Distinct | 67 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2123392785 |
|---|---|
| Minimum | 0 |
| Maximum | 1.04 |
| Zeros | 20961 |
| Zeros (%) | 11.8% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.1 |
| median | 0.17 |
| Q3 | 0.31 |
| 95-th percentile | 0.52 |
| Maximum | 1.04 |
| Range | 1.04 |
| Interquartile range (IQR) | 0.21 |
Descriptive statistics
| Standard deviation | 0.1753962678 |
|---|---|
| Coefficient of variation (CV) | 0.82601895 |
| Kurtosis | -0.5398523727 |
| Mean | 0.2123392785 |
| Median Absolute Deviation (MAD) | 0.12 |
| Skewness | 0.6714568202 |
| Sum | 37692.77 |
| Variance | 0.03076385077 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 20961 | 11.8% |
| 0.11 | 18579 | 10.5% |
| 0.51 | 9112 | 5.1% |
| 0.21 | 8501 | 4.8% |
| 0.41 | 7627 | 4.3% |
| 0.12 | 7331 | 4.1% |
| 0.15 | 6426 | 3.6% |
| 0.01 | 5813 | 3.3% |
| 0.22 | 5760 | 3.2% |
| 0.1 | 5445 | 3.1% |
| Other values (57) | 81957 |
| Value | Count | Frequency (%) |
| 0 | 20961 | |
| 0.01 | 5813 | 3.3% |
| 0.01 | 4600 | 2.6% |
| 0.02 | 2389 | 1.3% |
| 0.03 | 38 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.04 | 1 | < 0.1% |
| 0.75 | 478 | |
| 0.71 | 453 | |
| 0.7 | 210 | 0.1% |
| 0.61 | 637 |
LoanType
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Variable | |
|---|---|
| Fixed |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.714977016 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1369501 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Variable |
|---|---|
| 2nd row | Variable |
| 3rd row | Variable |
| 4th row | Variable |
| 5th row | Variable |
| Value | Count | Frequency (%) |
| Variable | 160647 | |
| Fixed | 16865 | 9.5% |
| Value | Count | Frequency (%) |
| variable | 160647 | |
| fixed | 16865 | 9.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 321294 | |
| i | 177512 | |
| e | 177512 | |
| V | 160647 | |
| r | 160647 | |
| b | 160647 | |
| l | 160647 | |
| F | 16865 | 1.2% |
| x | 16865 | 1.2% |
| d | 16865 | 1.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1191989 | |
| Uppercase Letter | 177512 | 13.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| a | 321294 | |
| i | 177512 | |
| e | 177512 | |
| r | 160647 | |
| b | 160647 | |
| l | 160647 | |
| x | 16865 | 1.4% |
| d | 16865 | 1.4% |
| Value | Count | Frequency (%) |
| V | 160647 | |
| F | 16865 | 9.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1369501 |
Most frequent character per script
| Value | Count | Frequency (%) |
| a | 321294 | |
| i | 177512 | |
| e | 177512 | |
| V | 160647 | |
| r | 160647 | |
| b | 160647 | |
| l | 160647 | |
| F | 16865 | 1.2% |
| x | 16865 | 1.2% |
| d | 16865 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1369501 |
Most frequent character per block
| Value | Count | Frequency (%) |
| a | 321294 | |
| i | 177512 | |
| e | 177512 | |
| V | 160647 | |
| r | 160647 | |
| b | 160647 | |
| l | 160647 | |
| F | 16865 | 1.2% |
| x | 16865 | 1.2% |
| d | 16865 | 1.2% |
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.03571026184 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros | 83856 |
| Zeros (%) | 47.2% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.05 |
| Q3 | 0.06666666667 |
| 95-th percentile | 0.08333333333 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.06666666667 |
Descriptive statistics
| Standard deviation | 0.03813390568 |
|---|---|
| Coefficient of variation (CV) | 1.067869674 |
| Kurtosis | 11.71007257 |
| Mean | 0.03571026184 |
| Median Absolute Deviation (MAD) | 0.05 |
| Skewness | 1.452749277 |
| Sum | 6339 |
| Variance | 0.001454194762 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 83856 | |
| 0.06666666667 | 17820 | 10.0% |
| 0.07142857143 | 13300 | 7.5% |
| 0.05263157895 | 10868 | 6.1% |
| 0.05555555556 | 10134 | 5.7% |
| 0.0625 | 10000 | 5.6% |
| 0.05 | 5820 | 3.3% |
| 0.05882352941 | 5695 | 3.2% |
| 0.07692307692 | 4654 | 2.6% |
| 0.04761904762 | 3675 | 2.1% |
| Other values (13) | 11690 | 6.6% |
| Value | Count | Frequency (%) |
| 0 | 83856 | |
| 0.04761904762 | 3675 | 2.1% |
| 0.05 | 5820 | 3.3% |
| 0.05263157895 | 10868 | 6.1% |
| 0.05555555556 | 10134 | 5.7% |
| Value | Count | Frequency (%) |
| 1 | 2 | < 0.1% |
| 0.5 | 32 | < 0.1% |
| 0.3333333333 | 114 | 0.1% |
| 0.25 | 300 | |
| 0.2 | 365 |
target
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 | |
|---|---|
| 1 | 3456 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 177512 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 174056 | |
| 1 | 3456 | 1.9% |
| Value | Count | Frequency (%) |
| 0 | 174056 | |
| 1 | 3456 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 174056 | |
| 1 | 3456 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 177512 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 174056 | |
| 1 | 3456 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 177512 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 174056 | |
| 1 | 3456 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 177512 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 174056 | |
| 1 | 3456 | 1.9% |
Browser_OS
Categorical
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Chrome_Windows | |
|---|---|
| Safari_iOS | |
| Chrome_Android | |
| Edge_Windows | |
| Chrome_Macintosh | |
| Other values (11) |
Length
| Max length | 23 |
|---|---|
| Median length | 14 |
| Mean length | 13.26903533 |
| Min length | 10 |
Characters and Unicode
| Total characters | 2355413 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Safari_iOS |
|---|---|
| 2nd row | Safari_iOS |
| 3rd row | Safari_iOS |
| 4th row | Safari_iOS |
| 5th row | Chrome_Android |
| Value | Count | Frequency (%) |
| Chrome_Windows | 50446 | |
| Safari_iOS | 48465 | |
| Chrome_Android | 26966 | |
| Edge_Windows | 12515 | 7.1% |
| Chrome_Macintosh | 11074 | 6.2% |
| SamsungInternet_Android | 7590 | 4.3% |
| Safari_Macintosh | 6489 | 3.7% |
| Others_Windows | 5425 | 3.1% |
| Chrome_iOS | 4082 | 2.3% |
| Others_Android | 2648 | 1.5% |
| Other values (6) | 1812 | 1.0% |
| Value | Count | Frequency (%) |
| chrome_windows | 50446 | |
| safari_ios | 48465 | |
| chrome_android | 26966 | |
| edge_windows | 12515 | 7.1% |
| chrome_macintosh | 11074 | 6.2% |
| samsunginternet_android | 7590 | 4.3% |
| safari_macintosh | 6489 | 3.7% |
| others_windows | 5425 | 3.1% |
| chrome_ios | 4082 | 2.3% |
| others_android | 2648 | 1.5% |
| Other values (6) | 1812 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 231940 | 9.8% |
| o | 217422 | 9.2% |
| r | 202725 | 8.6% |
| _ | 177512 | 7.5% |
| d | 155311 | 6.6% |
| n | 147211 | 6.2% |
| a | 136343 | 5.8% |
| e | 130677 | 5.5% |
| h | 121816 | 5.2% |
| S | 115101 | 4.9% |
| Other values (15) | 719355 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1762730 | |
| Uppercase Letter | 415171 | 17.6% |
| Connector Punctuation | 177512 | 7.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| i | 231940 | |
| o | 217422 | |
| r | 202725 | |
| d | 155311 | |
| n | 147211 | |
| a | 136343 | |
| e | 130677 | |
| h | 121816 | |
| s | 104805 | |
| m | 100583 | |
| Other values (6) | 213897 |
| Value | Count | Frequency (%) |
| S | 115101 | |
| C | 92990 | |
| W | 68386 | |
| O | 62538 | |
| A | 37204 | 9.0% |
| M | 18842 | 4.5% |
| E | 12517 | 3.0% |
| I | 7593 | 1.8% |
| Value | Count | Frequency (%) |
| _ | 177512 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2177901 | |
| Common | 177512 | 7.5% |
Most frequent character per script
| Value | Count | Frequency (%) |
| i | 231940 | 10.6% |
| o | 217422 | 10.0% |
| r | 202725 | 9.3% |
| d | 155311 | 7.1% |
| n | 147211 | 6.8% |
| a | 136343 | 6.3% |
| e | 130677 | 6.0% |
| h | 121816 | 5.6% |
| S | 115101 | 5.3% |
| s | 104805 | 4.8% |
| Other values (14) | 614550 |
| Value | Count | Frequency (%) |
| _ | 177512 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2355413 |
Most frequent character per block
| Value | Count | Frequency (%) |
| i | 231940 | 9.8% |
| o | 217422 | 9.2% |
| r | 202725 | 8.6% |
| _ | 177512 | 7.5% |
| d | 155311 | 6.6% |
| n | 147211 | 6.2% |
| a | 136343 | 5.8% |
| e | 130677 | 5.5% |
| h | 121816 | 5.2% |
| S | 115101 | 4.9% |
| Other values (15) | 719355 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Unnamed: 0 | click_type | Time_of_day | weekday | position | device | provider_name | rate | experts_choice | Region | rate_rank | min_interest | TotalImpressions | rate_var | LoanType | Big4Weight | target | Browser_OS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | GTS | 3 | Friday | 4 | mobile | Newcastle Permanent | 3.89 | True | Victoria | 2 | 3.74 | 4 | 0.15 | Variable | 0.25 | 0 | Safari_iOS |
| 1 | 2 | GTS | 3 | Friday | 5 | mobile | ME | 3.89 | False | Victoria | 3 | 3.74 | 4 | 0.15 | Variable | 0.25 | 0 | Safari_iOS |
| 2 | 3 | GTS | 3 | Friday | 6 | mobile | NAB | 3.99 | False | Victoria | 4 | 3.74 | 4 | 0.25 | Variable | 0.25 | 0 | Safari_iOS |
| 3 | 4 | GTS | 3 | Friday | 7 | mobile | AMP | 3.74 | False | Victoria | 1 | 3.74 | 4 | 0.00 | Variable | 0.25 | 0 | Safari_iOS |
| 4 | 5 | GTS | 6 | Friday | 1 | mobile | loans.com.au | 3.64 | True | South Australia | 3 | 3.59 | 7 | 0.05 | Variable | 0.00 | 0 | Chrome_Android |
| 5 | 6 | GTS | 6 | Friday | 2 | mobile | UBank | 3.59 | False | South Australia | 1 | 3.59 | 7 | 0.00 | Variable | 0.00 | 0 | Chrome_Android |
| 6 | 7 | GTS | 6 | Friday | 3 | mobile | HSBC | 3.59 | False | South Australia | 2 | 3.59 | 7 | 0.00 | Variable | 0.00 | 0 | Chrome_Android |
| 7 | 8 | GTS | 6 | Friday | 9 | mobile | Hunter United | 4.19 | False | South Australia | 7 | 3.59 | 7 | 0.60 | Variable | 0.00 | 0 | Chrome_Android |
| 8 | 9 | GTS | 6 | Friday | 8 | mobile | Gateway Bank | 3.64 | False | South Australia | 4 | 3.59 | 7 | 0.05 | Variable | 0.00 | 0 | Chrome_Android |
| 9 | 10 | GTS | 6 | Friday | 12 | mobile | Macquarie | 3.80 | False | South Australia | 5 | 3.59 | 7 | 0.21 | Variable | 0.00 | 0 | Chrome_Android |
Last rows
| Unnamed: 0 | click_type | Time_of_day | weekday | position | device | provider_name | rate | experts_choice | Region | rate_rank | min_interest | TotalImpressions | rate_var | LoanType | Big4Weight | target | Browser_OS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 177502 | 177503 | GTS | 23 | Friday | 7 | desktop | Newcastle Permanent | 3.89 | True | Victoria | 13 | 3.39 | 16 | 0.50 | Variable | 0.0 | 0 | Safari_Macintosh |
| 177503 | 177504 | GTS | 23 | Friday | 8 | desktop | Homestar | 3.49 | False | Victoria | 6 | 3.39 | 16 | 0.10 | Variable | 0.0 | 0 | Safari_Macintosh |
| 177504 | 177505 | GTS | 23 | Friday | 10 | desktop | Tic:Toc | 3.47 | True | Victoria | 3 | 3.39 | 16 | 0.08 | Variable | 0.0 | 0 | Safari_Macintosh |
| 177505 | 177506 | GTS | 23 | Friday | 11 | desktop | loans.com.au | 3.48 | False | Victoria | 5 | 3.39 | 16 | 0.09 | Fixed | 0.0 | 0 | Safari_Macintosh |
| 177506 | 177507 | GTS | 23 | Friday | 12 | desktop | Hunter United | 3.99 | False | Victoria | 14 | 3.39 | 16 | 0.60 | Variable | 0.0 | 0 | Safari_Macintosh |
| 177507 | 177508 | Lead | 23 | Friday | 13 | desktop | Virgin Money | 3.69 | False | Victoria | 12 | 3.39 | 16 | 0.30 | Variable | 0.0 | 0 | Safari_Macintosh |
| 177508 | 177509 | GTS | 23 | Friday | 14 | desktop | loans.com.au | 3.64 | True | Victoria | 10 | 3.39 | 16 | 0.25 | Variable | 0.0 | 0 | Safari_Macintosh |
| 177509 | 177510 | Lead | 23 | Friday | 15 | desktop | Bank of Queensland | 3.99 | False | Victoria | 15 | 3.39 | 16 | 0.60 | Variable | 0.0 | 0 | Safari_Macintosh |
| 177510 | 177511 | Lead | 23 | Friday | 16 | desktop | Aussie | 3.99 | False | Victoria | 16 | 3.39 | 16 | 0.60 | Variable | 0.0 | 0 | Safari_Macintosh |
| 177511 | 177512 | GTS | 23 | Friday | 18 | desktop | MOVE Bank | 3.59 | True | Victoria | 9 | 3.39 | 16 | 0.20 | Variable | 0.0 | 0 | Safari_Macintosh |